package com.zhz.crm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhz.crm.entity.User;
import org.apache.ibatis.annotations.*;

import javax.annotation.Resource;
import java.util.List;

public interface UserMapper extends BaseMapper<User> {
//    @Insert("INSERT INTO " +
//            "                sys_user " +
//            "                (usr_name,usr_password,usr_role_id,usr_flag) " +
//            "        VALUES " +
//            "                (#{usrName},#{usrPassword},#{usrRoleId},#{usrFlag})")
//    public void insert(User user );
//
//    @Delete("DELETE FROM " +
//            "                sys_user " +
//            "        WHERE " +
//            "                usr_id=#{id}")
//    public void delete(Long id);
//
//    @Update("<script>"+
//            "UPDATE " +
//            "        sys_user " +
//            "        <set> " +
//            "            <if test=\"usrName != null\">usr_name = #{usrName},</if> " +
//            "            <if test=\"usrPassword != null\">usr_password = #{usrPassword},</if> " +
//            "            <if test=\"usrRoleId != null\">usr_role_id = #{usrRoleId},</if> " +
//            "            <if test=\"usrFlag != null\">usr_flag = #{usrFlag},</if> " +
//            "        </set> " +
//            "        WHERE " +
//            "        usr_id = #{usrId}"+"</script>")
//    public void update(User user);
//
//    @Select("SELECT " +
//            "        usr_id,usr_name,usr_password,usr_role_id,usr_flag" +
//            "        FROM sys_user " +
//            "        WHERE usr_id = #{id}")
//    @Results({
//            @Result(column = "usr_id",property = "usrId"),
//            @Result(column = "usr_name",property = "usrName"),
//            @Result(column = "usr_password",property = "usrPassword"),
//            @Result(column = "usr_role_id",property = "usrRoleId"),
//            @Result(column = "usr_flag",property = "usrFlag")
//    })
//    public User get(Long id);
//
//    @Select("SELECT " +
//            "        usr_id,usr_name,usr_password,usr_role_id,usr_flag" +
//            "        FROM sys_user")
//    @Results({
//            @Result(column = "usr_id",property = "usrId"),
//            @Result(column = "usr_name",property = "usrName"),
//            @Result(column = "usr_password",property = "usrPassword"),
//            @Result(column = "usr_role_id",property = "usrRoleId"),
//            @Result(column = "usr_flag",property = "usrFlag")
//    })
//    public List<User> getAll();

}
